create table Measurement(
    id int generated by default as identity primary key ,
    temperature numeric not null ,
    rain boolean not null ,
    sensor_id int not null
);
insert into Measurement(temperature, rain, sensor_id) VALUES (25.4, false, 1);